﻿using System;
using System.Data;
using WP.Commons;

namespace WP.RM.DataEntity
{
    [System.ComponentModel.DesignerCategory("Code")]
    public class RMCategorySetBOMHdrDEL : DataSet, IDataEntity
    {
        //=========mCity ============================
        public const string TABLENAME_RMCATEGORYSet = "rmCategorySetBOMHdr";
        public const string RECID = "RecID";
        public const string RECSTAMP = "RecStamp";
        public const string CATEGORYNAME = "CategoryName";
        public const string SETNAME = "SetName";
        public const string Remark = "Remark";
        public const string TotalDetailCost = "TotalDetailCost";
        public const string TotalLabourCost = "TotalLabourCost";
        public const string TotalWastageCost = "TotalWastageCost";
        public const string TotalCost = "TotalCost";
        public const string CategoryID = "CategoryID";
        public const string SetID = "SetID";

            //public const string LabelUnitQty="LabelUnitQty";
            //public const string LabelLength="LabelLength";
            //public const string LabelWidth="LabelWidth";
            //public const string LabelSize = "LabelSize";
            //public const string PrintLength="PrintLength";
            //public const string PrintWidth="PrintWidth"; 
            //public const string LaminatingLength="LaminatingLength"; 
            //public const string LaminatingWidth="LaminatingWidth"; 
            //public const string CutFactor ="CutFactor";
            //public const string PrintUseQty ="PrintUseQty";
            //public const string ContainQty="ContainQty"; 
            //public const string PackageQty="PackageQty"; 
            //public const string InnerDiameterLength="InnerDiameterLength";
            //public const string InnerDiameterWidth ="InnerDiameterWidth";
            //public const string InnerDiameterHeight="InnerDiameterHeight";
            //public const string InnerOutsideDiff ="InnerOutsideDiff";
            //public const string MiddleWidth="MiddleWidth";
            //public const string BurrWidth ="BurrWidth";
            //public const string OtherPrintWidth="OtherPrintWidth"; 
            //public const string OtherPrintBackWidth="OtherPrintBackWidth" ;
            //public const string UseIronNailQty ="UseIronNailQty";
            //public const string LockingWireQty ="LockingWireQty";
            //public const string LockingWireLength = "LockingWireLength";
            public const string WorkCost = "WorkCost";
            
            //public const string OtherPrintPages="OtherPrintPages";
            //public const string MiddleLength="MiddleLength";
            //public const string  MiddlePages="MiddlePages";                

            public const string approval1 = "approval1";
            public const string approvalDate1 = "approvalDate1";
            public const string approvalPerson1 = "approvalPerson1";
            public const string approval2 = "approval2";
            public const string approvalDate2 = "approvalDate2";
            public const string approvalPerson2 = "approvalPerson2";
            public const string approval3 = "approval3";
            public const string approvalDate3 = "approvalDate3";
            public const string approvalPerson3 = "approvalPerson3";
            public const string approval4 = "approval4";
            public const string approvalDate4 = "approvalDate4";
            public const string approvalPerson4 = "approvalPerson4";
            public const string approval5 = "approval5";
            public const string approvalDate5 = "approvalDate5";
            public const string approvalPerson5 = "approvalPerson5";

            public const string approval = "approval";
            public const string approvalDate = "approvalDate";
            public const string approvalPerson = "approvalPerson";

        private System.Collections.Specialized.NameValueCollection mVarCollection = new System.Collections.Specialized.NameValueCollection();
        public System.Collections.Specialized.NameValueCollection VarCollection
        {
            get { return mVarCollection; }
            set { mVarCollection = value; }
        }

        public RMCategorySetBOMHdrDEL()
        {
            //Create mCity structure
            CreatemCityStructure();

        }

        //=========mCity============================
        private void CreatemCityStructure()
        {
            DataTable table;
            DataColumnCollection DCC;
            DataColumn DC = new DataColumn();
            table = new DataTable(TABLENAME_RMCATEGORYSet);
            DCC = table.Columns;

            DC = new DataColumn(RECID, typeof(System.Int32));
            DCC.Add(DC);

            DC = new DataColumn(CategoryID , typeof(System.String));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(SetID, typeof(System.String));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(CATEGORYNAME, typeof(System.String));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(SETNAME, typeof(System.String));
            DC.DefaultValue = 0;
            DCC.Add(DC);

            DC = new DataColumn(RECSTAMP, typeof(System.Byte[]));
            DCC.Add(DC);

            DC = new DataColumn(Remark, typeof(System.String));
            DC.DefaultValue = "";
            DCC.Add(DC);

            DC = new DataColumn(TotalCost, typeof(System.Double));
            DC.DefaultValue = "0";
            DCC.Add(DC);

            DC = new DataColumn(TotalDetailCost, typeof(System.Double));
            DC.DefaultValue = "0";
            DCC.Add(DC);

            DC = new DataColumn(TotalLabourCost, typeof(System.Double));
            DC.DefaultValue = "0";
            DCC.Add(DC);

            DC = new DataColumn(TotalWastageCost, typeof(System.Double));
            DC.DefaultValue = "0";
            DCC.Add(DC);
                              
            //DC = new DataColumn(LabelUnitQty, typeof(System.Double));
            //DC.DefaultValue = "0";
            //DCC.Add(DC);
	
        
            //DC = new DataColumn(LabelLength, typeof(System.Double));
            //DC.DefaultValue = "0";
            //DCC.Add(DC);
	 
        
            //DC = new DataColumn(LabelWidth, typeof(System.Double));
            //DC.DefaultValue = "0";
            //DCC.Add(DC);


            //DC = new DataColumn(LabelSize , typeof(System.Double));
            //DC.DefaultValue = "0";
            //DCC.Add(DC);


            //DC = new DataColumn(PrintLength, typeof(System.Double));
            //DC.DefaultValue = "0";
            //DCC.Add(DC);


	 
        
            //DC = new DataColumn(PrintWidth, typeof(System.Double));
            //DC.DefaultValue = "0";
            //DCC.Add(DC);
	 
        
            //DC = new DataColumn(LaminatingLength, typeof(System.Double));
            //DC.DefaultValue = "0";
            //DCC.Add(DC);
	 
        
            //DC = new DataColumn(LaminatingWidth, typeof(System.Double));
            //DC.DefaultValue = "0";
            //DCC.Add(DC);
	 
        
            //DC = new DataColumn(CutFactor, typeof(System.Double));
            //DC.DefaultValue = "0";
            //DCC.Add(DC);
	 
        
            //DC = new DataColumn(PrintUseQty, typeof(System.Double));
            //DC.DefaultValue = "0";
            //DCC.Add(DC);
	 
        
            //DC = new DataColumn(ContainQty, typeof(System.Double));
            //DC.DefaultValue = "0";
            //DCC.Add(DC);
	 
        
            //DC = new DataColumn(PackageQty, typeof(System.Double));
            //DC.DefaultValue = "0";
            //DCC.Add(DC);
	
        
            //DC = new DataColumn(InnerDiameterLength, typeof(System.Double));
            //DC.DefaultValue = "0";
            //DCC.Add(DC);
	 
        
            //DC = new DataColumn(InnerDiameterWidth, typeof(System.Double));
            //DC.DefaultValue = "0";
            //DCC.Add(DC);


            //DC = new DataColumn(InnerDiameterHeight, typeof(System.Double));
            //DC.DefaultValue = "0";
            //DCC.Add(DC);


            //DC = new DataColumn(InnerOutsideDiff, typeof(System.Double));
            //DC.DefaultValue = "0";
            //DCC.Add(DC);


            //DC = new DataColumn(MiddleWidth, typeof(System.Double));
            //DC.DefaultValue = "0";
            //DCC.Add(DC);


            //DC = new DataColumn(BurrWidth, typeof(System.Double));
            //DC.DefaultValue = "0";
            //DCC.Add(DC);


            //DC = new DataColumn(OtherPrintWidth, typeof(System.Double));
            //DC.DefaultValue = "0";
            //DCC.Add(DC);


            //DC = new DataColumn(OtherPrintBackWidth, typeof(System.Double));
            //DC.DefaultValue = "0";
            //DCC.Add(DC);


            //DC = new DataColumn(UseIronNailQty, typeof(System.Double));
            //DC.DefaultValue = "0";
            //DCC.Add(DC);


            //DC = new DataColumn(LockingWireQty, typeof(System.Double));
            //DC.DefaultValue = "0";
            //DCC.Add(DC);


            //DC = new DataColumn(LockingWireLength, typeof(System.Double));
            //DC.DefaultValue = "0";
            //DCC.Add(DC);

            DC = new DataColumn(WorkCost , typeof(System.Double));
            DC.DefaultValue = "0";
            DCC.Add(DC);

            DC = new DataColumn(approval , typeof(System.String));
            DC.DefaultValue = "";
            DCC.Add(DC);
            DC = new DataColumn(approvalDate , typeof(System.DateTime));
            DCC.Add(DC);
            DC = new DataColumn(approvalPerson , typeof(System.String));
            DC.DefaultValue = "";
            DCC.Add(DC);

            DC = new DataColumn(approval1, typeof(System.String));
            DC.DefaultValue = "";
            DCC.Add(DC);
            DC = new DataColumn(approvalDate1, typeof(System.DateTime));
            DCC.Add(DC);
            DC = new DataColumn(approvalPerson1, typeof(System.String));
            DC.DefaultValue = "";
            DCC.Add(DC);
            DC = new DataColumn(approval2, typeof(System.String));
            DC.DefaultValue = "";
            DCC.Add(DC);
            DC = new DataColumn(approvalDate2, typeof(System.DateTime));
            DCC.Add(DC);
            DC = new DataColumn(approvalPerson2, typeof(System.String));
            DC.DefaultValue = "";
            DCC.Add(DC);
            DC = new DataColumn(approval3, typeof(System.String));
            DC.DefaultValue = "";
            DCC.Add(DC);
            DC = new DataColumn(approvalDate3, typeof(System.DateTime));
            DCC.Add(DC);
            DC = new DataColumn(approvalPerson3, typeof(System.String));
            DC.DefaultValue = "";
            DCC.Add(DC);
            DC = new DataColumn(approval4, typeof(System.String));
            DC.DefaultValue = "";
            DCC.Add(DC);
            DC = new DataColumn(approvalDate4, typeof(System.DateTime));
            DCC.Add(DC);
            DC = new DataColumn(approvalPerson4, typeof(System.String));
            DC.DefaultValue = "";
            DCC.Add(DC);
            DC = new DataColumn(approval5, typeof(System.String));
            DC.DefaultValue = "";
            DCC.Add(DC);
            DC = new DataColumn(approvalDate5, typeof(System.DateTime));
            DCC.Add(DC);
            DC = new DataColumn(approvalPerson5, typeof(System.String));
            DC.DefaultValue = "";
            DCC.Add(DC);
            this.Tables.Add(table);
        }
    }
}
